AfterUpdate Event

       

Occurs after changed data has been written to the database from a DataGrid control.

Syntax

Sub object_AfterUpdate (index As Integer)

The AfterUpdate event syntax has these parts:

Part Description
object An object expression that evaluates to an object in the Applies To list.
index An integer that identifies a control if it is in a control array.

Remarks

When the user moves to another row, or the Recordset object's Update method is executed, data is moved from the control's copy buffer to the Data control's copy buffer and written to the database. Once the write is complete, the AfterUpdate event is triggered.

The updated record is available by using the Bookmark property of the DataGrid control.

The AfterUpdate event occurs after the BeforeUpdate event, but before the LostFocus event for the control (or GotFocus for the next control in the tab order). This event occurs in bound and unbound mode and can't be canceled.

Unlike the Change event, changing data in a control or record using code doesn't trigger this event.